package com.bkgy.modular.qualityCheckRecord.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

import java.sql.Timestamp;

/**
 * @author
 * @version 1.0
 * @ClassName QualityCheckRecord
 * @date 2023/5/29 13:48
 */
@Data
public class QualityCheckRecord {

    @ExcelProperty("日期")
    @ColumnWidth(20)
    @DateTimeFormat("yyyy-MM-dd")
    private Timestamp date1;

    @ExcelProperty("班别")
    @ColumnWidth(20)
    private String crew;

    @ExcelProperty("班次")
    @ColumnWidth(20)
    private String shift;

    @ExcelProperty("连退卷号")
    @ColumnWidth(20)
    private String extid;

    @ExcelProperty("酸轧卷号")
    @ColumnWidth(20)
    private String entid;

    @ExcelProperty("钢种")
    @ColumnWidth(20)
    private String steel_code;

    @ExcelProperty("内部牌号")
    @ColumnWidth(20)
    private String sg_sign;

    @ExcelProperty("计划宽度(mm)")
    @ColumnWidth(20)
    private String order_width;

    @ExcelProperty("计划宽度最大值（mm）")
    @ColumnWidth(20)
    private String out_mat_width_max;

    @ExcelProperty("计划宽度最小值（mm）")
    @ColumnWidth(20)
    private String out_mat_width_min;

    @ExcelProperty("连退入口原料宽度(mm)")
    @ColumnWidth(20)
    private String in_mat_width;

    @ExcelProperty("连退出口实测宽度(mm)")
    @ColumnWidth(20)
    private String ex_wid;

    @ExcelProperty("连退机组出入口宽度差(mm)")
    @ColumnWidth(20)
    private String wid_diff;

    @ExcelProperty("计划厚度(mm)")
    @ColumnWidth(20)
    private String order_thick;

    @ExcelProperty("计划厚度最大值(mm)")
    @ColumnWidth(20)
    private String thk_max;

    @ExcelProperty("计划厚度最小值（mm）")
    @ColumnWidth(20)
    private String thk_min;

    @ExcelProperty("连退入口原料厚度(mm)")
    @ColumnWidth(20)
    private String in_mat_thick;

    @ExcelProperty("连退实测厚度(mm)")
    @ColumnWidth(20)
    private String ex_thk;

    @ExcelProperty("入口原料长度(m)")
    @ColumnWidth(20)
    private String in_mat_len;

    @ExcelProperty("实测带钢粗糙度(um)(在线)")
    @ColumnWidth(20)
    private String rough_online;

    @ExcelProperty("实测带钢粗糙度(um)(手持)(外板)")
    @ColumnWidth(20)
    private String rough_measure;

    @ExcelProperty("PC值(外板)")
    @ColumnWidth(20)
    private String pc;

    @ExcelProperty("工艺特殊指示")
    @ColumnWidth(20)
    private String order_special;

    @ExcelProperty("合同特殊要求")
    @ColumnWidth(20)
    private String special_remark;

    @ExcelProperty("原料卷重(t)")
    @ColumnWidth(20)
    private String in_mat_wt;

    @ExcelProperty("成品卷重下限(t)")
    @ColumnWidth(20)
    private String cut_wt_min;

    @ExcelProperty("成品卷重上限(t)")
    @ColumnWidth(20)
    private String cut_wt_max;

    @ExcelProperty("成品卷重(t)")
    @ColumnWidth(20)
    private String act_wt;

    @ExcelProperty("成品卷长(m)")
    @ColumnWidth(20)
    private String act_length;

    @ExcelProperty("入口异常剪切量(m)")
    @ColumnWidth(20)
    private String en_cut_abnormal;

    @ExcelProperty("半卷回退量(t)")
    @ColumnWidth(20)
    private String half_coilback_wt;

    @ExcelProperty("出口异常剪切量(m)")
    @ColumnWidth(20)
    private String ex_cut_abnormal;

    @ExcelProperty("油品使用情况")
    @ColumnWidth(20)
    private String oil_using;

    @ExcelProperty("涂油量(g/m2)")
    @ColumnWidth(20)
    private String top_oil_qty;

    @ExcelProperty("下道工序")
    @ColumnWidth(20)
    private String next_unit_no;

    @ExcelProperty("标准缺陷名称")
    @ColumnWidth(20)
    private String standard_defect;

    @ExcelProperty("主要缺陷描述")
    @ColumnWidth(20)
    private String main_defect;

    @ExcelProperty("质量异常情况原因分析")
    @ColumnWidth(20)
    private String quality_analysis;

    @ExcelProperty("责任归属代码")
    @ColumnWidth(20)
    private String responsibility_code;

    @ExcelProperty("过渡卷或实验计划")
    @ColumnWidth(20)
    private String dummy_coil;

    @ExcelProperty("副  缺  陷1")
    @ColumnWidth(20)
    private String sub_defect1;

    @ExcelProperty("副  缺  陷2")
    @ColumnWidth(20)
    private String sub_defect2;

    @ExcelProperty("分选度")
    @ColumnWidth(20)
    private String sort_grade;

    @ExcelProperty("质监站是否确认")
    @ColumnWidth(20)
    private String quality_station_ensurn;

    @ExcelProperty("质监站确认者")
    @ColumnWidth(20)
    private String quality_station_confirmer;

    @ExcelProperty("酸轧质量信息记录")
    @ColumnWidth(20)
    private String defect_desc;

    @ExcelProperty("是否取样")
    @ColumnWidth(20)
    private String sample;

    @ExcelProperty("表面结构")
    @ColumnWidth(20)
    private String surface_structure;

    @ExcelProperty("外形尺寸")
    @ColumnWidth(20)
    private String shape_size;

    @ExcelProperty("表面质量尺寸判定")
    @ColumnWidth(20)
    private String surface_quality_judge;

    @ExcelProperty("质量检查")
    @ColumnWidth(20)
    private String quality_check;

    @ExcelProperty("质量预警与叫停情况")
    @ColumnWidth(20)
    private String quality_warn;

    @ExcelProperty("订单合同号")
    @ColumnWidth(20)
    private String order_no;

    @ExcelProperty("用户ID")
    @ColumnWidth(20)
    private String fin_user_name;

    @ExcelProperty("订单用途")
    @ColumnWidth(20)
    private String apn_desc;

    @ExcelProperty("销售类型")
    @ColumnWidth(20)
    private String export_flag;

    @ExcelProperty("质检员签字")
    @ColumnWidth(20)
    private String quality_sign;

    @ExcelProperty("判钢建议1(分厂填写)")
    @ColumnWidth(20)
    private String steel_judgment1;

    @ExcelProperty("缺陷照片代码")
    @ColumnWidth(20)
    private String defect_photo_code;

    @ExcelProperty("备注(分厂填写)")
    @ColumnWidth(20)
    private String remarks_branch;

    @ExcelProperty("判钢建议2(质检站填写)")
    @ColumnWidth(20)
    private String steel_judgment2;

    @ExcelProperty("合格品情况")
    @ColumnWidth(20)
    private String qualified_products;

    @ExcelProperty("合格品脱单情况")
    @ColumnWidth(20)
    private String qualified_products_delisting;

    @ExcelProperty("让步接收情况")
    @ColumnWidth(20)
    private String concessive_acceptance;

    @ExcelProperty("可利用材情况")
    @ColumnWidth(20)
    private String available_materials;

    @ExcelProperty("材损情况")
    @ColumnWidth(20)
    private String material_damage;

    @ExcelProperty("终判描述")
    @ColumnWidth(20)
    private String final_judgment_description;

    @ExcelProperty("终判结果")
    @ColumnWidth(20)
    private String final_judgment_result;

    @ExcelProperty("终判钢种")
    @ColumnWidth(20)
    private String final_judgment_steel;

    @ExcelProperty("综判时间")
    @ColumnWidth(20)
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
    private Timestamp final_judgment_time;

    @ExcelProperty("备注(质检站填写)")
    @ColumnWidth(20)
    private String quality_station_remark;

    @ExcelProperty("待判备注")
    @ColumnWidth(20)
    private String pending_remarks;

    @ExcelProperty("成材率")
    @ColumnWidth(20)
    private String yield;

    @ExcelProperty("湿度")
    @ColumnWidth(20)
    private String humidity;

//    @ExcelProperty("生产开始时间")
//    @ColumnWidth(20)
//    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
//    private String process_start_time;
//
//    @ExcelProperty("生产结束时间")
//    @ColumnWidth(20)
//    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")
//    private String process_end_time;
}
